RE: Why does this fail

2005-08-16 Thread Andrew Hargreaves
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 16 August 2005 15:04 To: Andrew Hargreaves Cc: mysql@lists.mysql.com Subject: Re: Why does this fail "Andrew Hargreaves" <[EMAIL PROTECTED]> wrote on 08/16/2005 09:13:56 AM: > Can anyone e

Re: Why does this fail

2005-08-16 Thread SGreen
"Andrew Hargreaves" <[EMAIL PROTECTED]> wrote on 08/16/2005 09:13:56 AM: > Can anyone explain why this SQL statement would fail? A friend was asked it > in a pre-interview assessment and it threw him a bit. > > SELECT T1.BldgName T1.StreetName, T1.Locality, T1.PostTown from PstlAddr T1 > Where

RE: Why does this fail

2005-08-16 Thread Andrew Hargreaves
Isn't AS optional? -Original Message- From: Raz [mailto:[EMAIL PROTECTED] Sent: 16 August 2005 14:19 To: Andrew Hargreaves Cc: mysql@lists.mysql.com Subject: Re: Why does this fail For a start, spot the missing AS... raz -- No virus found in this incoming message. Checked by AVG

RE: Why does this fail

2005-08-16 Thread Jay Blanchard
[snip] Can anyone explain why this SQL statement would fail? A friend was asked it in a pre-interview assessment and it threw him a bit. SELECT T1.BldgName T1.StreetName, T1.Locality, T1.PostTown from PstlAddr T1 Where T1.City='London' AND NOT EXISTS (SELECT T2.Pstl_Address_PK from PrsnAddress T2

Re: Why does this fail

2005-08-16 Thread Scott Noyes
> Can anyone explain why this SQL statement would fail? A friend was asked it > in a pre-interview assessment and it threw him a bit. > > SELECT T1.BldgName T1.StreetName, T1.Locality, T1.PostTown from PstlAddr T1 > Where T1.City='London' AND NOT EXISTS (SELECT T2.Pstl_Address_PK from > PrsnAddres

RE: Why does this fail

2005-08-16 Thread J.R. Bullington
w Hargreaves [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 16, 2005 9:14 AM To: mysql@lists.mysql.com Subject: Why does this fail Can anyone explain why this SQL statement would fail? A friend was asked it in a pre-interview assessment and it threw him a bit. SELECT T1.BldgName T1.StreetN

Re: Why does this fail

2005-08-16 Thread Raz
For a start, spot the missing AS... raz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Why does this fail

2005-08-16 Thread Andrew Hargreaves
Can anyone explain why this SQL statement would fail? A friend was asked it in a pre-interview assessment and it threw him a bit. SELECT T1.BldgName T1.StreetName, T1.Locality, T1.PostTown from PstlAddr T1 Where T1.City='London' AND NOT EXISTS (SELECT T2.Pstl_Address_PK from PrsnAddress T2)