Can SQL do this?

Results 1 to 3 of 3

Thread: Can SQL do this?

  1. #1
    Terry Jeske Guest

    Default Can SQL do this?

    Hello,<BR><BR>I have two tables:<BR><BR>CUSTInfo<BR> userID<BR> name<BR> city<BR> state<BR><BR>CUSTSite<BR> siteID<BR> userID<BR> disabled<BR><BR>What I need is to find all the DISTINCT states from the CUSTInfo table, But first I have to filter out records WHERE CUSTSite.disabled is true.<BR><BR>Any ideas?<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Can SQL do this?

    &nbsp;<BR>What about this:<BR><BR>SELECT Distinct CUSTInfo.state <BR>FROM CUSTSite, CUSTInfo<BR>WHERE CUSTSite.disabled &#060;&#062; true<BR>AND CUSTInfo.userID = CUSTSite.userID<BR><BR>???<BR><BR>

  3. #3
    Terry Jeske Guest

    Default RE: Can SQL do this?

    Right on! Thank you very much.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts