
05.05.2005, 14:05
|
|
Новичок
Регистрация: 02.05.2005
Сообщений: 6
С нами:
11064660
Репутация:
0
|
|
[I]SELECT m.[q], m.[w], m.[e], m.[r], m.[t], m.[y],m.[u], m., m.[a], m.[s], m.[d], me.[q],
me.[g], me.[f] FROM [db_name] m
LEFT JOIN [db_name2] me ON me.[z]=m.[z]
LEFT JOIN [db_name3] g ON m.[x]=g.[z] WHERE m.[z] > 0 AND m.[x]='1' AND g.[c] <> 1
ORDER BY m.[q] asc LIMIT 1, UNION UPDATE [db_name] SET [x] = [y] WHERE [z] = 0/*
|
|
|