working with views
| From: | Harpreet | Date: | Thu, 06 Dec 2001 19:40:08 +0000 |
| Subject: | working with views | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-14846@lists.php.net to get a copy of this message | ||
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.