SELECT STATEMENT

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I AM TRING TO SELECT CITY AND STATE/PROVINCE FROM MY CUSTOMER TABLE AND RETURN THERE VALUES WHEN MY CUSTOMERS.CUSTOMER ID AND QUOTE .CUSTOMER ID ARE EQUAL. I'M NOT SURE HOW TO DO THIS
IF ANYONE KNOWS YOU HELP WOULD BE GREATLY APPRECIATED
THANKS
SHAW

THIS IS WHAT I HAVE SO FAR

=(SELECT [CUSTOMER].[CITY],[CUSTOMER].[STATE].PROVINCE FORM [CUSTOMERS] WHERE [CUSTOMERS].[CUSTOMER ID]=
.[CUSTOMER ID]
Click to expand...
 
Have you tried making it is a query, then copying the SQL
from that query and pasting it where you need it?

This is also a good way to test your SQL.

Brad

-----Original Message-----
I AM TRING TO SELECT CITY AND STATE/PROVINCE FROM MY
Click to expand...
CUSTOMER TABLE AND RETURN THERE VALUES WHEN MY
CUSTOMERS.CUSTOMER ID AND QUOTE .CUSTOMER ID ARE EQUAL.
I'M NOT SURE HOW TO DO THIS.
IF ANYONE KNOWS YOU HELP WOULD BE GREATLY APPRECIATED.
THANKS
SHAWN

THIS IS WHAT I HAVE SO FAR.

=(SELECT [CUSTOMER].[CITY],[CUSTOMER].[STATE].PROVINCE
Click to expand...
FORM [CUSTOMERS] WHERE [CUSTOMERS].[CUSTOMER ID]=
.
[CUSTOMER ID])
Click to expand...
 
You're shouting (all caps) try speaking softly and maybe we can help!


Shawn said:
I AM TRING TO SELECT CITY AND STATE/PROVINCE FROM MY CUSTOMER TABLE AND RETURN
Click to expand...
THERE VALUES WHEN MY CUSTOMERS.CUSTOMER ID AND QUOTE .CUSTOMER ID ARE EQUAL. I'M
NOT SURE HOW TO DO THIS.
IF ANYONE KNOWS YOU HELP WOULD BE GREATLY APPRECIATED.
THANKS
SHAWN

THIS IS WHAT I HAVE SO FAR.

=(SELECT [CUSTOMER].[CITY],[CUSTOMER].[STATE].PROVINCE FORM [CUSTOMERS] WHERE [CUSTOMERS].[CUSTOMER ID]=.[CUSTOMER ID])
Click to expand...
 
If your tables are related tables, You don't need to write "WHERE" statement.
If not, You do that in right way.

You can do that using "INNER JOIN", "INNER JOIN LEFT" or "INNER JOIN RIGHT" statement.
Read help files with these themes.
 
Back
Top