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. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php