Search results for query: *

Thanks very much :)

Hi, Sorry it didn't occur to me as I test locally using mysql 4. I know the host is a dinosaur - very annoying. Thanks for all your help though. Rob

I know this should be a mysql question but it's to do with this thread. The sql above uses a nested select in the inner join - does this work with all mysql versions? I'm forced to be using 3.23.56 on my web server

Thanks for that - I will post in the MySQL one from now on! Now time to try and fit this into a larger query that's being built using PHP :(

Also will this work in MySQL? and finally can it be done on multiple fields, i.e. many different test_questionyes's?

r937, OK thanks that looks like it complex enough :) Would you mind explaining it a little so that I know the reason behind it? I just hate to modify something without knowing how it's meant to work.

My tables are little more complex but the example below explains my problem in more simple terms. Table1 test_id test_name Table2 table2_id test_id test_questionyes1 test_questionyes2 I would like to select the distinct test_id's where all the rows in Table2 have questionyes1 set to 1 and...

Fixed it. Turns out it wasn't the connection string at all so all's good.

That didn't seem to work but thanks for responding. My old conn string was: Server=ROBLAPTOP\\SQLEXPRESS;Database=DatabaseName1;Trusted_Connection=True; When i was using just the DatabaseName1 databases. It's currently: Server=ROBLAPTOP\\SQLEXPRESS;Trusted_Connection=True; But this does not...

I have an SQL server instance and have two databases (this is not avoidable due to the client) I want to be able to use one connection string to access both and then in the queries use: databasename.dbo.tablename to access the tables. What connection string will work and do I need to change...