The following worked in MSSQL as it could handle views. Now i want to run it in PHP with a mysql server. I was wondering if there is another alternative for the below then to use temporary tables.
select * from dev_device_view b inner join cch_playlist_view a on b.source_name =a.video_source where dev_device_view and cch_playlist_views are sql statements joining 2 tables using an inner join. Help is appreciated, regards, Harpreet Kaur Software Developer Crispin Corporations Inc. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]