SQl statement
| From: | (Sharon Spurvey) | Date: | Tue, 07 Nov 2000 19:19:47 +0000 |
| Subject: | SQl statement | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-24170@lists.php.net to get a copy of this message | ||
I am having trouble getting this SQL statement to work with Oracle. Can
anyone see any obvious problems with it? I know it is a little F**ked
up, sorry.
UPDATE Img_Folder_Search, Index_Table, User_Fields_Table
SET Img_Folder_Search.And_Level=1
WHERE Img_Folder_Search.Image_ID=Index_Table.Image_ID AND
Img_Folder_Search.User_Number='1000001'
AND User_Fields_Table.User_Number=Img_Folder_Search.User_Number AND
User_Fields_Table.Field_Name=Index_Table.Field_Name
AND (Img_Folder_Search.And_Level=0 AND UPPER(Index_Table.Index_Data)
LIKE 'ice' AND Cat_ID = 'IS')
tia
mdp