- Jun 16, 2004
- 1,034
- 0
- 0
Sorry, I'm just starting off with some SQL programing, and haven't been able to find too many good books at the library. Could someone help me figure out what a query should be like in the following circumstance? (This is using Access 2003 by the way).
Let's say that I have three fields in the table LOCATION: CITY, STATE and COUNTRY.
I'd like to write a query that will return CITY, STATE if the COUNTRY is "USA" and CITY, COUNTRY if the COUNTRY is not "USA."
I can do the concatenate thing with "&" but I'm not sure how to do the rest.
Thanks in advance. Hopefully, I can work from this and figure out some more SQL.
Let's say that I have three fields in the table LOCATION: CITY, STATE and COUNTRY.
I'd like to write a query that will return CITY, STATE if the COUNTRY is "USA" and CITY, COUNTRY if the COUNTRY is not "USA."
I can do the concatenate thing with "&" but I'm not sure how to do the rest.
Thanks in advance. Hopefully, I can work from this and figure out some more SQL.