SQL SEVER

[ad.hasareli]

Good mrng machanla....

Lokuma loku help akak oni wela tamai me tread aka danne SQL danne netnam plz bump akak wath dila support akak denna....


Menna mekai wenna oni,
Akama billno aken table 3ma value thiyenawa nam table 3ma value display karanna ona...akama billno aken table 2ka witarai nam valuve thiyenne a table 2 display karala anith table ake valuwe Null widihata display karanna oni (sometime akama billno aken value thiyenna puluwan 1 table akaka witak wennath puluwan ehema unoth anith table 2kema valuve Null widihata display karanna ona).... yatin mama table 3 screen short 3k attach karanawa

Ane mata onna okata SQL akak liyala dennako plz loku help akak.

 

[hirushan]

CREATE TABLE table1(
billno int,
billinfo varchar(50)
)

CREATE TABLE table2(
billno int,
billinfo varchar(50)
)

CREATE TABLE table3(
billno int,
billinfo varchar(50)
)

--3 Tables
Insert into table1 values (1111,'Marie')
Insert into table2 values (1111,'Marie')
Insert into table3 values (1111,'Marie')

--Only 2 Tables
Insert into table1 values (1112,'Hirushan')
Insert into table2 values (1112,'Hirushan')

--Only 1 
Insert into table1 values (1113,'Eranga')

select * from table1
select * from table2
select * from table3

--All 3
select table1.billno as [table1-BillNo],
	   table1.billinfo as [table1-BillInfo],
	   table2.billinfo as [table2-BillInfo],
	   table3.billinfo as [table3-BillInfo] 
from table1
INNER JOIN table2 
	ON table1.billno=table2.billno
INNER JOIN table3
	ON table1.billno=table3.billno


--2 only
select table1.billno as [table1-BillNo],
	   table1.billinfo as [table1-BillInfo],
	   table2.billinfo as [table2-BillInfo],
	   table3.billinfo as [table3-BillInfo] 
from table1
INNER JOIN table2 
	ON table1.billno=table2.billno
LEFT JOIN table3
	ON table1.billno=table3.billno

--only 1
select table1.billno as [table1-BillNo],
	   table1.billinfo as [table1-BillInfo],
	   table2.billinfo as [table2-BillInfo],
	   table3.billinfo as [table3-BillInfo] 
from table1
LEFT JOIN table2 
	ON table1.billno=table2.billno
LEFT JOIN table3
	ON table1.billno=table3.billno

 

[ad.hasareli]

bump

thnx machan

 

[hirushan]

If you need more information regarding the Sql Joins please use the following Link :

http://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins

 

[ad.hasareli]

CREATE TABLE table1(
billno int,
billinfo varchar(50)
)

CREATE TABLE table2(
billno int,
billinfo varchar(50)
)

CREATE TABLE table3(
billno int,
billinfo varchar(50)
)

--3 Tables
Insert into table1 values (1111,'Marie')
Insert into table2 values (1111,'Marie')
Insert into table3 values (1111,'Marie')

--Only 2 Tables
Insert into table1 values (1112,'Hirushan')
Insert into table2 values (1112,'Hirushan')

--Only 1 
Insert into table1 values (1113,'Eranga')

select * from table1
select * from table2
select * from table3

--All 3
select table1.billno as [table1-BillNo],
       table1.billinfo as [table1-BillInfo],
       table2.billinfo as [table2-BillInfo],
       table3.billinfo as [table3-BillInfo] 
from table1
INNER JOIN table2 
    ON table1.billno=table2.billno
INNER JOIN table3
    ON table1.billno=table3.billno


--2 only
select table1.billno as [table1-BillNo],
       table1.billinfo as [table1-BillInfo],
       table2.billinfo as [table2-BillInfo],
       table3.billinfo as [table3-BillInfo] 
from table1
INNER JOIN table2 
    ON table1.billno=table2.billno
LEFT JOIN table3
    ON table1.billno=table3.billno

--only 1
select table1.billno as [table1-BillNo],
       table1.billinfo as [table1-BillInfo],
       table2.billinfo as [table2-BillInfo],
       table3.billinfo as [table3-BillInfo] 
from table1
LEFT JOIN table2 
    ON table1.billno=table2.billno
LEFT JOIN table3
    ON table1.billno=table3.billno

terune nam nehe machan...check ur pm

 

[ad.hasareli]

bmp

 

[ad.hasareli]

apita udau karanna SQL weddo nehe wage

 

[ad.hasareli]

bmp

 

[wsvperera]

select *
from Bill B,Rotation R, Return+item RI
where B.billno = R.billno

union

select *
from Bill B,Rotation R, Return+item RI
where RI.billno = R.billno

union

select *
from Bill B,Rotation R, Return+item RI
where B.billno = RI.billno

 

[ad.hasareli]

select *
from Bill B,Rotation R, Return+item RI
where B.billno = R.billno

union

select *
from Bill B,Rotation R, Return+item RI
where RI.billno = R.billno

union

select *
from Bill B,Rotation R, Return+item RI
where B.billno = RI.billno

mekat hari yanne nehe ban data duplicate wenawa.... recodes 76 display karanawa ban

 

[wsvperera]

Tabels wala Primery key(s) monawada ?

 

[ad.hasareli]

Tabels wala Primery key(s) monawada ?

billno machan

 

[wsvperera]

Meka C# or java Program ekak ekka use wena ekak da ?

 

[ad.hasareli]

Meka C# or java Program ekak ekka use wena ekak da ?

ow machan.............. .net

 

[wsvperera]

ow machan.............. .net

ASP.net da C# da VB da ?

 

[ad.hasareli]

ASP.net da C# da VB da ?

vb.net machan.... mata ubage email aka pm akarapan machan...ditls tika mail akak dannm.

 

[ad.hasareli]

bmp

 

[ltty head]

i think this will help you up with few modifications.. to return null instead of dash (-). depend on ur database you may use isnull() function..

select a.billno, a.billinfo,b.billinfo,c.billinfo from table1 a full join table2 b on a.billno=b.billno full join table3 c on b.billno=c.billno;

please note: this is with reference to the tables given by hirushan

 

[ltty head]

bump

 

[agnipra]

Left outer joint ekak dala baluvada machan!!!