|
|
Joined: May 2004
Posts: 1
Lurker
|
Lurker
Joined: May 2004
Posts: 1 |
I am trying to perform a unique lookup using these two tables:
assessments asmtID | scaleID ---------------------- 2 | 1 2 | 3 2 | 4
scales scaleID | custID | Name ------------------------------- 1 | 0 | test1 3 | 0 | test2 3 | 1 | custom 4 | 0 | test3
I want to select one record for each of the scale records that has a match in the assessments table, but I want the record with the custID =1 (if it exist) or otherwise the record with custID = 0 I've gotten myself stuck on this one for awhile now and would love it if someone has a query that can solve.
Thanks
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
Posts: 21,079
Joined: March 2000
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|