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 expnameexpamount 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 BIGINTDatevalue date) CREATE TABLE TEMP2(ID BIGINTDatevalue date) INSERT INTO TEMP1 SELECT 1'2014-09-03' UNION SELECT 2'2014-09-04' UNION SELECT 3NULL UNION SELECT 4NULL INSERT INTO TEMP2 SELECT 1'2014-09-03' UNION SELECT 2'2014-09-05' UNION SELECT 4NULL UNION SELECT 5NULL 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