FROM A LEFT JOIN B ON A.C=B.D WHERE B.D IS NULL
- Original Message -
From: "Aaron Cannon" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, January 03, 2007 3:47 PM
Subject: select statement question
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all. I hope this is the ri
Aaron Cannon wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all. I hope this is the right place to ask this.
I have two tables, A and B. Each of these tables has a column with
integers. The column in table A is C and the one in B is D.
SELECT c.value FROM c WHERE c.value NOT IN
om
> Subject: select statement question
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hi all. I hope this is the right place to ask this.
>
> I have two tables, A and B. Each of these tables has a column with
> integers. The column in table A is C and
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all. I hope this is the right place to ask this.
I have two tables, A and B. Each of these tables has a column with
integers. The column in table A is C and the one in B is D.
I need a select statement that will return all records whose C valu
I know this'll look scary :
select distinct book.bid, title, price, condition, author.name, edition from book left
join purchase on book.bid=purchase.bid left join student on 1 = 1 left join edition on
edition.bid = book.bid left join author on 1 = 1 left join author_book on 1 = 1 where
purcha
***Greene***
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 22, 2003 4:18 PM
> To: [EMAIL PROTECTED]
> Subject: select statement question
>
>
> how do I get the values of foreign keys, that I have used within a
how do I get the values of foreign keys, that I have used within a
database
example
Main_DB
Main_Table
PK title_id3
FK manufacturer_id 5
FK category_id 4
Manufacturer_Table
PK manufacturer_id 5
description
x27;t" (Unknown)
- Original Message -
From: "Jordan Morgan" <[EMAIL PROTECTED]>
To: "Nobody" <[EMAIL PROTECTED]>
Cc: "Diana Soares" <[EMAIL PROTECTED]>; "mysql" <[EMAIL PROTECTED]>
Sent: Friday, October 10, 2003 2:24 PM
Subj
nd binary and those who don't" (Unknown)
> - Original Message -
> From: "Diana Soares" <[EMAIL PROTECTED]>
> To: "Jordan Morgan" <[EMAIL PROTECTED]>
> Cc: "mysql" <[EMAIL PROTECTED]>
> Sent: Friday, October 10, 2003 8:5
oh thanks! I guess that's why I'm a newbie.
Diana Soares wrote:
> Look at:
>
> if ($tenureid=3)
>
> You're not comparing $tenureid with 3, you're assigning 3 to
> $ternureid... If you want to compare both values, you must use the
> operator "==" (and not only "=").
>
> On Fri, 2003-10-10 at 0
ot; <[EMAIL PROTECTED]>
To: "Jordan Morgan" <[EMAIL PROTECTED]>
Cc: "mysql" <[EMAIL PROTECTED]>
Sent: Friday, October 10, 2003 8:58 AM
Subject: Re: newbie select statement question
> Look at:
>
> if ($tenureid=3)
>
> You're not comparing $tenure
Look at:
if ($tenureid=3)
You're not comparing $tenureid with 3, you're assigning 3 to
$ternureid... If you want to compare both values, you must use the
operator "==" (and not only "=").
On Fri, 2003-10-10 at 05:43, Jordan Morgan wrote:
> Hi,
>
> I have the following statement:
>
> echo "$te
Hi,
I have the following statement:
echo "$tenureid";
if ($tenureid=3)
{
// get faculty employment record - award date
$sql = "select TD.Award_Date from TenureDescription TD LEFT JOIN
InstitutionEmployment IE on TD.TenureDescriptionID=IE.Tenure WHERE
IE.FacultyMember='$fid'";
$result = mysq
thanks for the chuckle. we've all been beginners
and i still do dumb things with sql.
download corereader from http://corereader.com
it will let you click on the database objects to
build your queries. when you click on your table
name and your field name, it will return the data
to you an
> When I run SELECT * FROM POSTCODE; in mysql prompt I get garbled display of
> data and some of my data is not shown.
the garbled display is probably due to the results being wider then the
screen/terminal, and since the mysql client doesn't implement a horizontal
scrollbar like a gui/web mysql
You should write:
SELECT postcode FROM TABLE_NAME;
This will display the postcode from your table?
Jfernand
** sql **
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: November 20, 2002 16:12
To: [EMAIL PROTECTED]
Subject: SELECT Statement Question
Hi
I am
Hi
I am a beginner in using mysql on Windows platform, and I have a question regarding
the use of "SELECT * from TABLE_NAME" statement within the mysql prompt.
I have a table of consisting of three columns POSTCODE, SUBURB, STATE where
the primary key is a composite of all three fields.
When I r
17 matches
Mail list logo