ot; <[EMAIL PROTECTED]>
> To: "mysQL List" <[EMAIL PROTECTED]>
> Sent: Tuesday, March 18, 2003 11:49 AM
> Subject: Re: Selecting only ONCE from multiple tables
>
>
> > Hal Vaughan wrote:
> >
> > >I'd like to be able to select from both tab
MAIL PROTECTED]>
Sent: Tuesday, March 18, 2003 11:49 AM
Subject: Re: Selecting only ONCE from multiple tables
> Hal Vaughan wrote:
>
> >I'd like to be able to select from both tables and get one listing.
> >
> >Table 1 is Cases, Table 2 is Temp. They have columns
Hal Vaughan wrote:
I'd like to be able to select from both tables and get one listing.
Table 1 is Cases, Table 2 is Temp. They have columns Name, Amount, Zip.
SELECT * FROM Cases AS C, Temp AS T WHERE (C.Amount > 500 OR T.Amount > 500);
produces a list of 38 rows w/ 6 columns (the first 3 colu
