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