Re: simple SQL Question

Subject: RE: simple SQL Question That is a left outer join. It's mixing new and old styles of joining tables. Not sure if there's a benefit to the mix, but I reckon this is clearer: SELECT a.id, b.name FROM a INNER JOIN b ON a.id = b.id LEFT OUTER JOIN b ON a.id = b.id Is this code actually

RE: simple SQL Question

That is a left outer join. It's mixing new and old styles of joining tables. Not sure if there's a benefit to the mix, but I reckon this is clearer: SELECT a.id, b.name FROM a INNER JOIN b ON a.id = b.id LEFT OUTER JOIN b ON a.id = b.id Is this code actually used or an example for the question?

Re: simple SQL Question

*= is actually used at my work place.  Thanks for the answer. From: Adrian Lynch cont...@adrianlynch.co.uk To: cf-talk cf-talk@houseoffusion.com Sent: Friday, August 21, 2009 5:59:17 PM Subject: RE: simple SQL Question That is a left outer join. It's mixing

Re: Simple SQL Question

I believe you need to separate fields with a comma. Hope that helps. - Mark :o) - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 14, 2000 3:12 PM Subject: Simple SQL Question Ok I want to "conjugate" 3 fields when i am inserting into a

Re: Simple SQL Question

If you are adding 3 records to the DB then you do this: cfquery name"addit" datasource="whatever" INSERT INTO Data(Fieldone) Values('#form.dat1#) /cfquery cfquery name"addit" datasource="whatever" INSERT INTO Data(Fieldone) Values('#form.dat2#) /cfquery cfquery name"addit" datasource="whatever"

Re: Simple SQL Question

Scratch that last email I didn't look very close, sorry! If you are just inserting into one table then why not use CFINSERT dataSource="database" tableName="table" and then pass whatever from your form. Or am I misunderstanding what your doing? -Mark :o) - Original Message - From:

Re: Simple SQL Question

On 9/14/00, [EMAIL PROTECTED] penned: Ok I want to "conjugate" 3 fields when i am inserting into a database. this is what i have, but it won't work, am i missing something??? cfquery datasource="data" name="add" INSERT INTO Data(data1) VALUES('#FORM.dat1# #FORM.dat2# #FORM.dat3#') /cfquery

RE: Simple SQL Question

Try this... INSERT INTO TableName (FieldName1,FieldName2,FieldName3) VALUES ('#Form.Dat1#','#Form.Dat2#','#Form.Dat3#') -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 14, 2000 6:13 PM To: [EMAIL PROTECTED] Subject: Simple SQL Question