aminpourazadeh
شنبه 26 مرداد 1387, 20:28 عصر
دو تا پرسجو هست که می خوام ازشون اشتراک بگیرم ...روی کلمه کلیدیintersect ایراد میگیره!!!!میشه زود جواب بدید
SELECT Tbl_Book.Book_name, Tbl_Book.Book_author, Tbl_Book.id_book,Tbl_Book.Book_entsharat, Tbl_Book.Book_date_nashr, Tbl_Book.Book_price,
Tbl_Book.Book_number, Tbl_Book.Book_motarjem, Tbl_Ghorfe.Ghorfe_name, Tbl_Book.Book_discription, Tbl_Book.Book_id_ghorfe
FROM Tbl_Book INNER JOIN
Tbl_Ghorfe ON Tbl_Book.Book_id_ghorfe = Tbl_Ghorfe.id_ghorfe
WHERE (Tbl_Book.Book_entsharat LIKE N'%' + LTRIM(RTRIM(@Book_entsharat)) + N'%')
intersect
SELECT Tbl_Book.Book_name, Tbl_Book.Book_author, Tbl_Book.id_book,Tbl_Book.Book_entsharat, Tbl_Book.Book_date_nashr, Tbl_Book.Book_price,
Tbl_Book.Book_number, Tbl_Book.Book_motarjem, Tbl_Ghorfe.Ghorfe_name, Tbl_Book.Book_discription, Tbl_Book.Book_id_ghorfe
FROM Tbl_Book INNER JOIN
Tbl_Ghorfe ON Tbl_Book.Book_id_ghorfe = Tbl_Ghorfe.id_ghorfe
WHERE (Tbl_Book.Book_author LIKE N'%' + LTRIM(RTRIM(@Book_author)) + N'%')
SELECT Tbl_Book.Book_name, Tbl_Book.Book_author, Tbl_Book.id_book,Tbl_Book.Book_entsharat, Tbl_Book.Book_date_nashr, Tbl_Book.Book_price,
Tbl_Book.Book_number, Tbl_Book.Book_motarjem, Tbl_Ghorfe.Ghorfe_name, Tbl_Book.Book_discription, Tbl_Book.Book_id_ghorfe
FROM Tbl_Book INNER JOIN
Tbl_Ghorfe ON Tbl_Book.Book_id_ghorfe = Tbl_Ghorfe.id_ghorfe
WHERE (Tbl_Book.Book_entsharat LIKE N'%' + LTRIM(RTRIM(@Book_entsharat)) + N'%')
intersect
SELECT Tbl_Book.Book_name, Tbl_Book.Book_author, Tbl_Book.id_book,Tbl_Book.Book_entsharat, Tbl_Book.Book_date_nashr, Tbl_Book.Book_price,
Tbl_Book.Book_number, Tbl_Book.Book_motarjem, Tbl_Ghorfe.Ghorfe_name, Tbl_Book.Book_discription, Tbl_Book.Book_id_ghorfe
FROM Tbl_Book INNER JOIN
Tbl_Ghorfe ON Tbl_Book.Book_id_ghorfe = Tbl_Ghorfe.id_ghorfe
WHERE (Tbl_Book.Book_author LIKE N'%' + LTRIM(RTRIM(@Book_author)) + N'%')