subquery syntax

Hello: I am new to this and am having trouble with subqueries. Using MySQL 3.23 I have a Contacts table, and a Users table each with a ContactId field. I want to retrieve the ContactID from the Users table where UserName and UserPassword are such and such, I then want to get the FirstName and

Re: subquery syntax

Is the idea, then, to string queries together, the result of one feeding the next? Thanks David On Tuesday, July 30, 2002, at 11:28 AM, Jeff Dyer wrote: > Forget it (at least for the forseeable future) > > This is the well known MySQL feature that means that MySQL is not even > SQL > compati

Re: mySQL & CF5 - auto increment??

Hi Flash: This is a shot in the dark, but when I set up some tables using phpMyAdmin, I set a field to auto_increment and a default value of 0, phpMyAdmin created the table, but without the default value. When I add records from a form, it increments correctly. Perhaps the default value sho