non matching rows

Question

hi syntax of non matching rows in a query with where clause in sql with example

Vulpes · Answer

'unoin' should be 'union'.

Maneesh A N · Answer

hi please make it correct? create procedure prcexpincbalprint ( @month varchar(50), @year varchar(50) ) as select expname,expamount from tblexpense where month(dbilldate)=@month and year(dbilldate)=@year unoin select vpayment from tblpayments where month(dbilldate)=@month and year(dbilldate)=@year error found Msg 102, Level 15, State 1, Procedure prcexpincbalprint, Line 9 Incorrect syntax near 'unoin'.

DRISHTY · Answer

BEGIN CREATE TABLE TEMP1(ID BIGINT,Datevalue date) CREATE TABLE TEMP2(ID BIGINT,Datevalue date) INSERT INTO TEMP1 SELECT 1,'2014-09-03' UNION SELECT 2,'2014-09-04' UNION SELECT 3,NULL UNION SELECT 4,NULL INSERT INTO TEMP2 SELECT 1,'2014-09-03' UNION SELECT 2,'2014-09-05' UNION SELECT 4,NULL UNION SELECT 5,NULL SELECT * FROM TEMP1 SELECT * FROM TEMP2 SELECT * FROM TEMP1 FULL OUTER JOIN TEMP2 ON TEMP1.Datevalue = TEMP2.Datevalue WHERE TEMP1.Datevalue IS NULL OR TEMP2.Datevalue IS NULL DROP TABLE TEMP1 DROP TABLE TEMP2 END

Maneesh A N · Answer

syntax of non matching rows in a query with where clause in sql having same field(means 'date')with example.both tables having date.so how can i give date to where clause with null values

DRISHTY · Answer

Check this : http://stackoverflow.com/questions/5840217/sql-query-help-to-get-non-matching-records-from-two-tables

non matching rows

Answers (5)