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
I'm just getting used to SQL/MySQL, so there is likely a name for this or it
may be well known -- I just haven't either come across it, or haven't made
the associations between all the parts yet.
I have 2 tables, one a temp table, and they have the same columns. I'd like
to be able to select f