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,

Harpreet Kaur
Software Developer
Crispin Corporations Inc.

PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to