SELECT STATEMENT

From: Brad (anonymous_at_discussions.microsoft.com)
Date: 04/27/04 

Date: Tue, 27 Apr 2004 13:32:00 -0700

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
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
FORM [CUSTOMERS] WHERE [CUSTOMERS].[CUSTOMER ID]=[QUOTE].
[CUSTOMER ID])
>
>
>.
>