Join Query With Three Tables

Aug 30, 2013

I need to make a query to extract data from three tables.The tables are:

Customer

CREATE TABLE [Customer] (
[CustomerCode] VARCHAR(20) PRIMARY KEY NULL,
[CustomerName] VARCHAR(60) NULL,
[CustomerNif] VARCHAR(10) NULL,

[code]....

I wrote this SQL Query based in several tutorial on the net:

"SELECT c.CustomerName, sh.IncidentDesc, sh.IncidentTechInCharge, sih.IncidentChangeTo, sih.IncidentChangeDate FROM Customer c INNER JOIN SupportHistory sh ON c.CustomerCode = 'sh.IncidentCustomerCode' INNER JOIN SupportIncidentHistory sih ON sh.IncidentID = sih.IncidentID"

but it does not return any results.

View 5 Replies


ADVERTISEMENT

Query To Join 3 Tables

Nov 15, 2013

I have 2 tables:

Element(Element_Id, Element_Name) and Parent_Child(Parent_Id, Child_Id). Parent_Id and Child Id are actually the element Ids only. An element can have more than 1 parent or more than one child.

Now i want the output like this:

Element_Id Element_Name Parent_Name Child_Name

View 3 Replies View Related

3 Tables Join Query Provlem

Oct 26, 2004

Hi

I had a problem in my query and i expalined in detail in the following link


http://www.balainfo.com/forums/viewtopic.php?t=39

View 2 Replies View Related

Query That Join Two Tables And Retrieve A Sum

Jan 13, 2012

I want to join two tables of information together. I want to bring the order information together with the order charge. But since the OrderCharges table can have multiple values, I just want to retrieve the sum of those charges for a specific OrderID+ItemID.

My data looks something like this:

CREATE TABLE #OrderItems
(
OrderItemsID INT IDENTITY (1,1) PRIMARY KEY,
OrderID INT,
ItemID INT
)
SET IDENTITY_INSERT #OrderItems ON

[Code] ....

So I'm looking to see a result set that would like this this:

OrderItemsID-----ItemID-----OrderID----OrderDescription--OrderCharge
----1------------124---------1------------Shipping----------6.55
----2------------156---------1------------Shipping---------16.85
----3------------156---------2------------Shipping----------7.40
----4------------158---------1------------Shipping----------7.85
----5------------158---------2------------Shipping---------15.25

View 2 Replies View Related

Related Tables: Help Needed With JOIN Query

Oct 16, 2006

Hi Group,My apologies for the lengthy post, but here goes...I have the following tables:TABLE Vehicles([ID] nvarchar(5),[Make] nvarchar(20),[Model] nvarchar(20),)TABLE [Vehicle Status]([ID] int, /* this is an auto-incrementing field*/[Vehicle ID] nvarchar(5), /* foriegn key, references Vehicles.[ID] */[Status] nvarchar(20),[Status Date] datetime)Here's my problem...I have the following data in my [Vehicles] and [Vehicle Status] tables:[ID] [Make] [Model]----------------------H80 Nissan SkylineH86 Toyota Aristo[ID] [Vehicle ID] [Status] [Status Date]----------------------------------------1 H80 OK 2006-10-012 H80 Damage 2006-10-053 H86 OK 2006-10-134 H86 Dent 2006-10-155 H86 Scratched 2006-10-16I need a query that will join the two tables so that the most recentstatus of each vehicle can be determined. I've gotten as far as:SELECT Vehicle.[ID], Make, Model, [Status], [Status Date] FROM[Vehicles] INNER JOIN [Vehicle Status] ON [Vehicles].[ID] = [VehicleStatus].[Vehicle ID]Of course this produces the following results:[ID] [Make] [Model] [Status] [Status Date]--------------------------------------------H80 Nissan Skyline OK 2006-10-01H80 Nissan Skyline Damage 2006-10-05H86 Toyota Aristo OK 2006-10-13H86 Toyota Aristo Dent 2006-10-15H86 Toyota Aristo Scratched 2006-10-16How do I filter these results so that I get only the MOST RECENT vehiclestatus?i.e:[ID] [Make] [Model] [Status] [Status Date]--------------------------------------------H80 Nissan Skyline Damage 2006-10-05H86 Toyota Aristo Scratched 2006-10-16Thanks in advance,Rommel the iCeMAn*** Sent via Developersdex http://www.developersdex.com ***

View 1 Replies View Related

Sql Query Which Uses Multiple Tables But No Common Field To Join

Jan 29, 2004

Hello-

I have a sql query that I am using to populate a datagrid. The problem is one of the tables is a month table. and the other tables are full of data. So there is no common column name to match using a inner join "on".

How do i do this?

View 6 Replies View Related

How To Join 3 Tables Using Left Or Right Join Keyword?

Aug 17, 2007

Hi guys,

I'll appreciate any help with the following problem:

I need to retrieve data from 3 tables. 2 master tables and 1 transaction table.

1. Master table TBLOC contain 2 records :
rcd 1. S01
rcd 2. S02

2. Master table TBCODE contain 5 records:

rcd 1. C1
rcd 2. C2
rcd 3. C3
rcd 4. C4
rcd 5. C5

3. Transaction table TBITEM contain 4 records which link to 2 master table:
rcd 1. S01, C1, CAR

rcd 2. S01, C4, TOY
rcd 3. S01, C5, KEY
rcd 4. S02, C2, CAR



I use Left Join & Right Join to retrieve result below (using non-ASNI method) but it doesn't work.

Right Join method:


SELECT C.LOC, B.CODE, A.ITEM FROM TBITEM A RIGHT JOIN TBCODE B ON A.CODE = B.CODE

RIGHT JOIN TBLOC C ON A.LOC = C.LOC

GROUP BY C.LOC, B.CODE, A.ITEM ORDER BY C.LOC, B.CODE



When I use Non-ASNI method it work:



SELECT C.LOC, B.CODE, A.ITEM FROM TBITEM A, TBCODE B, TBLOC C

WHERE A.CODE =* B.CODE AND A.LOC =* C.LOC

GROUP BY C.LOC, B.CODE, A.ITEM ORDER BY C.LOC, B.CODE

Result:

LOC CODE ITEM
-----------------------------
S01 C1 NULL
S01 C2 NULL
S01 C3 CAR
S01 C4 TOY
S01 C5 KEY
S02 C1 NULL
S02 C2 CAR
S02 C3 NULL
S02 C4 NULL
S02 C5 NULL


Please Help.

Thanks.






View 3 Replies View Related

Multi-table JOIN Query With More Than One JOIN Statement

Apr 14, 2015

I'm having trouble with a multi-table JOIN statement with more than one JOIN statement.

For each order, I need to return the following: CarsID, CarModelName, MakeID, OrderDate, ProductName, Total ordered the Car Category.

The carid (primary key) and carmodelname belong to the Cars table.
The makeid and orderdate belong to the OrderDetails table.
The productname and carcategory belong to the Product table.

The number of rows returned should be the same as the number of rows in OrderDetails.

View 2 Replies View Related

Why Does My Query Timeout Unless Force Join To Hash Join?

Jul 25, 2007

I'm using SQL Server 2005.



A piece of software I wrote starting timing out on a query that left outer joins a table to a view. Both the table and view have approximately the same number of rows (about 170000).



The table has 2 very similar columns, one is a varchar(1) and another is varchar(100). Neither are included in any index and beyond the size difference, the columns have the same properties. One of the employees here uses the varchar(1) column (called miscsearch) to tag large sets of rows to perform some action on. In this case, he had set 9000 rows miscsearch value to "g". The query then should join the table and view for all rows where miscsearch is set to g in the table. This query takes at least 20 minutes to run (I stopped it at this point).

If I remove the "where" clause and join all rows in the two tables, the query completes in about 20 seconds. If set the varchar(100) column (called descrip) to "g" for the same rows set via miscsearch, the query completes in about 20 seconds.



If I force the join type to a hash join, the query completes using miscsearch in about 30 seconds.



So, this works:

SELECT di.File_No, prevPlacements, balance,'NOT PLACED' as status FROM Info di LEFT OUTER HASH JOIN View_PP pp ON di.ram_file_no = pp.file_no WHERE miscsearch = 'g' ORDER BY balance DESC



and this works:

SELECT di.File_No, prevPlacements, balance,'NOT PLACED' as status FROM Info di LEFT OUTER JOIN View_PP pp ON di.ram_file_no = pp.file_no WHERE descrip = 'g' ORDER BY balance DESC



But this does't:

SELECT di.File_No, prevPlacements, balance,'NOT PLACED' as status FROM Info di LEFT OUTER JOIN View_PP pp ON di.ram_file_no = pp.file_no WHERE miscsearch = 'g' ORDER BY balance DESC



What should I be looking for here to understand why this is happening?



Thanks,

john















View 1 Replies View Related

SQL Query Question - JOIN Or Not To JOIN

Jan 2, 2006

I have 2 tables, I will add sample data to them to help me explain...Table1(Fields: A, B)=====1,One2,Two3,ThreeTable2(Fields: A,B)=====2,deux9,neufI want to create a query that will only return data so long as the key(Field A) is on both tables, if not, return nothing. How can I dothis? I am thnking about using a 'JOIN' but not sure how to implementit...i.e: 2 would return data- but 9 would not...any help would be appreciated.

View 3 Replies View Related

JOIN TABLES...help!

Dec 21, 2006

hi,
this are my tables...






student




stud_num
pk2
pk3
stud_group

1234
11        
22   
1

2147
88        
66   
2

2222
22        
22   
2

5432
55        
44   
1

9876
99        
77   
1






student1






stud_num
pk2
pk3
age
grade
pass

1234
11        
22   
21
77
0

5432
55        
44   
23
90
1

9876
99        
77   
23
90
1






student2
 
 
 
 
 

stud_num
pk2
pk3
age
grade
pass

2147
88        
66   
18
78
0

2222
22        
22   
15
90
1
and this is what I want to retrieve from these 3 tables






stud_num
pk2
pk3
age

5432
55        
44   
23

9876
99        
77   
23

2222
22        
22   
15
this my query....
SELECT          student.stud_num, student.pk2, student.pk3, student1.age,                       student2.age AS Expr1FROM            student INNER JOIN                      student1 ON student.stud_num = student1.stud_num AND                       student.pk2 = student1.pk2 AND student.pk3 = student1.pk3 INNER JOIN                      student2 ON student.stud_num = student2.stud_num AND                       student.pk2 = student2.pk2 AND student.pk3 = student2.pk3WHERE           (student1.grade = '90') AND (student1.pass = '1') AND (student2.grade = '90')                       AND (student2.pass = '1')
however...it doesnt return any results...
can anyone correct my code?
 
thanx!
 
Sheila 
 

View 5 Replies View Related

How To Join Two Tables

Jun 23, 2007

I have two tables in sql server database. Tables are
Authors
AuthorName varchar (primary key), AuthorImage varchar
Threads
ThreadID int Primary Key, ThreadAuthor varchar, ForumID int (Foreign Key), ThreadReplyID int, ThreadPostedDate int
I have this query:
"SELECT ThreadAuthor, ThreadSubject, ThreadPost, ThreadPostedDate , ForumID FROM Threads WHERE ThreadID = " + threadId + " OR ThreadReplyID = " + threadId + " ORDER BY ThreadPostedDate ASC"
but i want to display AuthorImage on my webpage. How to modify the existing query to get the Author's image also.
Plz help me out anyone there.
Thanks

View 3 Replies View Related

If I Want To Join Two Sql Tables ...

Aug 22, 2007

do they have to have a common primary key?

View 13 Replies View Related

How To Join This Tables

Sep 6, 2007

i've two tables.
such as tableA and table B
table A has a column named CreatedBY and table B the same column..
now i need to get only the rows which match with table A's createdby column..
suppose tableA has only 2 values. when i make the join with tableB it shows as 4 values

View 8 Replies View Related

A Join On Six Tables

Sep 7, 2007

I need to perform a join on six different tables to produce a report. The biggest join I have ever done has been four tables. The way I did that query was to join three tables and then to perform the final select on the three table join.
Can anyone give me some advice. Should I use the same approach? Or can I just continue to use the keyword INNER JOIN to perform the joins?
 

View 1 Replies View Related

Join Of Tables

Apr 11, 2008

How to join two tables in database(sqlserver2005)(i gave primary key for each table)

View 1 Replies View Related

What Happens When I Join Tables ?

Apr 22, 2006

I am curios about what really happens when I join two tables?

Does a SQL server  create a runtime table and write that table to disk is there is not sufficent space in RAM?

View 5 Replies View Related

Join Tables

Jun 11, 2001

I have three tables:

1) Orders - order_id, orderdate
2) ordersdetails - order_id, partnumber, qty
3) products - partnumber

I need an output in following format

Date Partnumber qty


Following query gives the desired results.

select left(orders.orderdate,11) as date, orderdetails.partnumber, SUM(orderdetails.qty) as total
from orderdetails, orders
where orderdetails.partnumber is not null
and orderdetails.order_id = orders.order_id
and orders.orderdate >= {ts'2001-05-01 00:00:00'} and orders.orderdate <= {ts'2001-05-31 23:59:59'}
group by orders.orderdate, orderdetails.partnumber
order by orders.orderdate, total



But I do not have part that have null orders. My goal is to get

1) Get all part numbers, qty in the month of May.
2) at the end attach all partnumbers that have null ordered values to see which one have no orders.

View 1 Replies View Related

Join Tables

May 10, 2000

I have tables (tab#1, tab#2, tab#3, tab#4) that made of the orginal table(tab#0)

What I want to do is to join all tables(tab#1 through tab#4) to tab#0.

Tables look like;

1)tab#0
key_id, code
2)tab#1
id, code#1
3)tab#2
id, code#2
4)tab#3
id, code#3
5)tab#4
id, code#4

Any idea?

View 1 Replies View Related

Join Tables

Jan 11, 2001

Hi,

I have 2 tables. One with col1,col2 and second one with
col1,col2,col3. My requirement is to compare col1,col2
of t1 with t2 and update only changed records in t2.
How to implement? Please advise.

Thanks

Sam

View 1 Replies View Related

Join 3 Tables

Jul 21, 2006

Thank you, Thank you for reading my question!!! :)


I have 3 tables that need to be joined.
(Not necessarily needed info but might help: using Coldfusion with ODBC to Foxpro database)

Table 1: Timecard
--------
loginname date wrknum time
----------- --------- --------- ------
afrank 7/17/06 1 3
afrank 7/17/06 2 2
afrank 7/17/06 3 3
afrank 5/20/06 1 3
rjohn 7/17/06 1 3
.....

Table 2: Defaults
-----------
loginname wrknum
----------- ---------
afrank 1
afrank 2
afrank 3
afrank 4
afrank 5
....

Table 3: Workorders
wrknum description
---------- ---------------
1 descrip1
2 descrip2
.....


The result needs to be for the user afrank, date=7/20
and would look like:

Resultant Table:
loginname wrknum time description
----------- ---------- ------ ------------
afrank 1 3 descrip1
afrank 2 2 descrip2
afrank 3 3 descrip3
afrank 4 NULL descrip4
afrank 5 NULL descrip5


I've tried an outer left join but cannot get the right data. Basically everything from the timecard table and the leftovers from the default table with descriptions for all.

View 3 Replies View Related

Join Two Tables Using Sum And Max

Nov 30, 2004

I've got two tables, one called clientsharedeals and the clientorderdeals. In the first table, I have four fields (Rundate, Accno, Dealid, Nominal) that I need to sum(Nominal), grouping by dealid.

Once I've done this, I need to join to clientorderdeals, also having the same fields plus one extra (Rundate, Accno, Dealid, Nominal and Dealseq). Because of Dealseq, I can have more than one row in the table, matching (Rundate, Accno, Dealid, Nominal) of the first table. However, Dealseq increments, so I need to select max(Dealseq).

My query is doubling up on nominal because in my select statement, I am only using one account number, so I know what the value is for nominal and there are two rows in clientorderdeals - and it is not selecting max(dealseq) but both.

Can someone please cast some pearls my way ?

Thanks

View 1 Replies View Related

Join Tables Help

Dec 20, 2004

Could somebody please explain to me how do we join a table onto itself as that is what I was advised to do but I can't quite get where I want to go.

What I want to do is list values from a table,but those values can be just a quote (what would cost if they decided to go for that option) or those values can represent what was spent and invoiced, what is confusing me is that all of that gets saved in the same table and in same columns, so what was quoted for example for AirFares and what was spent gets saved in the same record but when it is "quoted amount" then ID = 1 but when it is invoiced ID = -1 and that is how we know what was quoted and what was invoiced.

But I need to split that one field into two columns one showing AirFareQuoted and one AirFareInvoiced and i have no idea how to achieve this.

I hope this makes sense and somebody can help me

View 14 Replies View Related

3 Tables To Join

Dec 28, 2004

hi,
I knew how to join 2 tables but i have a process to select 3 tables. I have a sample table and field below. I want to join Parts & Orders using field Prt_no and Supplier & Parts using field Sup _code



Parts table Orders Table Supplier Table
Prt_no Prt_no Sup_code
Prt_name Oh_qt Sup_name
Re_Level Or_no
Pri_amnt
Sup_code

Thanks...

View 2 Replies View Related

Join Two Tables From Different Dbs

Apr 28, 2006

Hi,

have to tables t1 and t2
t1 is in database db1
t2 is in db db2

Is it possible to join these two tables with an sql statement. or do i have to join my two datasets in my c#- Code

Greetz

View 3 Replies View Related

JOIN For Tables

Oct 9, 2007

Hey Folks,
I am stuck at one place in data migration........ I have the following source tables having no PK / INDEX / Constraint defined on any of them........


T1
(
ID1 INT,
STYLE VARCHAR(34)
)

T2
(
COL_ID VARCHAR(34),
OBJ_ID VARCHAR(34)
)

T3
(
OUT_ID VARCHAR(34),
ITEM VARCHAR(34),
)


And here is the relation..........


Quote:
T1.STYLE = T2.COL_ID

T2.OBJ_ID = T3.OUT_ID

T3.ITEM = T2.COL_ID




Here is what I have tried with.........

Quote:
SELECT * FROM T3 WHERE ITEM IN
(
SELECT COL_ID
FROM T1
INNER JOIN T2
ON
T1.STYLE = T2.COL_ID
INNER JOIN T3
ON
T2.OBJ_ID = T3.OUT_ID
)



But this query is not helping me out. I mean the number of output records are 0.

Now can any one suggest me a join that includes all the 3 tables, or finetune my query?



Thanks,
Rahul Jha

View 12 Replies View Related

How To Join All These Tables

Apr 9, 2008

Hi,

Hello how can we see the result of this query in single table . I am new with this and i dont know how to use join and all syntax.

SELECT request_session_id,resource_type,
request_status, request_type,request_reference_count,

resource_database_id FROM sys.dm_tran_locks

go

select getdate () as Date,@@servername as servername, name ,size*8/1024 as size_MB
from sys.master_files;

go

SELECT request_session_id,resource_type,
request_status, request_type,request_reference_count,

resource_database_id FROM sys.dm_tran_locks

select cpu ,memusage,hostname from sysprocesses

CREATE PROCEDURE dbo.usp_ShowAvailableSpace

AS

SELECT name AS NameOfFile,

size/128.0 -CAST(FILEPROPERTY(name, 'SpaceUsed' )AS int)/128.0 AS AvailableSpaceInMB
FROM dbo.SYSFILES

GO

EXEC usp_ShowAvailableSpace

select * from sys.sysprocesses

SELECT (a.cntr_value * 1.0 / b.cntr_value) * 100.0 [BufferCacheHitRatio]

FROM (SELECT *, 1 x FROM sys.dm_os_performance_counters
WHERE counter_name = 'Buffer cache hit ratio')

a

,

(SELECT *, 1 x FROM sys.dm_os_performance_counters
WHERE counter_name = 'Buffer cache hit ratio base')

b

select * from sys.dm_exec_sessions

select creation_time ,last_execution_time,execution_count ,

total_physical_reads,last_physical_reads,min_physical_reads,

max_physical_reads,total_logical_writes,

last_logical_writes,min_logical_writes,max_logical_writes,

last_elapsed_time,min_elapsed_time,max_elapsed_time

from sys.dm_exec_query_stats

View 2 Replies View Related

Inner Join For More Than 2 Tables

Apr 9, 2008

sorry for the noob question.
anyone know how to use inner join, left join or right join to join more than 2 tables? e.g. 3 tables
Thanks in advanced

View 4 Replies View Related

Join Two Tables?

Jun 21, 2008

hi everybody
I have a question and need answer as soon as possible. so i hope i get help. How can i join two tables have no common fields? I tried outer join but i get redundant data(repeated values).



Give me a script to solve the following problem . There are no real wrong answers, but the more efficient and bulletproof the query is the better. Assign rooms to classes based on capacity using the Classes and Rooms tables. Rules: each class should have a room (and NULL if a room is not available). No class can be in a room where there are more students than capacity. No room can be used twice.



And this is the tables query:

CREATE TABLE Classes (

ClassID int NOT NULL,

Class varchar (50),

Students int NOT NULL, CONSTRAINT PK_Classes PRIMARY KEY CLUSTERED (ClassID

) )

GO

CREATE TABLE Rooms (

Room int NOT NULL,

Capacity int NOT NULL,

CONSTRAINT PK_Rooms PRIMARY KEY CLUSTERED (Room)

)

GO

INSERT INTO Classes (ClassID, Class, Students) VALUES (1, 'Whats New for SQL Server 2008', 65)

INSERT INTO Classes (ClassID, Class, Students) VALUES (2, 'Introduction to Silverlight 1.1', 52)

INSERT INTO Classes (ClassID, Class, Students) VALUES (3, 'XQuery Deep Dive', 35)

INSERT INTO Classes (ClassID, Class, Students) VALUES (4, 'Ranking and Windowning', 35)

INSERT INTO Classes (ClassID, Class, Students) VALUES (5, 'Expression Blend 1.1', 65)

INSERT INTO Classes (ClassID, Class, Students) VALUES (6, 'Database Design Patterns', 75)

INSERT INTO Classes (ClassID, Class, Students) VALUES (7, 'CrossTabs for Dummies', 1)

INSERT INTO Rooms (Room, Capacity) VALUES (221, 30)

INSERT INTO Rooms (Room, Capacity) VALUES (222, 40)

INSERT INTO Rooms (Room, Capacity) VALUES (223, 50)

INSERT INTO Rooms (Room, Capacity) VALUES (224, 60)

INSERT INTO Rooms (Room, Capacity) VALUES (225, 70)

INSERT INTO Rooms (Room, Capacity) VALUES (226, 74)

GO

View 11 Replies View Related

Join In Two Tables

Oct 14, 2013

I have two tables:
T1 and T2.
T1 has 1 row as
name and age

T2 has 2 rows as
name, money1
name, money2

I use left outer join and get two rows in the resulting table.

As name, age, money1
and name, age, money2

Is there any way using which i can get data like:

name, age, money1, age, money2
in one row?

View 4 Replies View Related

Join Tables

Aug 30, 2006

i have 2 tables with a common ID in both tables.
one table has more number of rows than the other
i want to a query which gives the list of ids or rows which are missing in the other table.

left,right,inner jopins only give me common or common + right/left
i want only the missing once.

can someone help me with this

View 4 Replies View Related

Join Of Tables

Jan 5, 2007

hi,
i am facing an issue. i have got two tables say table1 and table2.
table1 has column1,2,3 ( has values a,b,c) where as table 2 has different columns 4,5,6(j,k,l).
column4 in table 2 has value which contains %+column1+% and it has two entires for each row in table1.the column4 value in table2 is different for all rows.When i am trying to join the two tables, i am getting values like

1 2 3 4 5 6
a b c j k l
a b c j1 k l
a1 b c j k l
a1 b c j1 k l

but i want to display
a b c k l
a1 b c k l

is there a way to do it.

My queries were
select distinct pc_assign_worklist.pxRefObjectInsName AS [pxRefObjectInsName],
pc_assign_worklist.pxUrgencyAssign AS [pxUrgencyAssign],
pc_assign_worklist.pyLabel AS [pyLabel],
pc_assign_worklist.pyAssignmentStatus AS [pyAssignmentStatus],
pc_assign_worklist.pxAssignedOperatorID AS [pxAssignedOperatorID],
CONVERT(char (11),pc_assign_worklist.pxCreateDateTime) AS [pxCreateDateTime],
pc_assign_worklist.pxCreateOpName AS [pxCreateOpName],
pc_index_workparty.MemberIdentifier AS [MemberIdentifier],
pc_index_workparty.LastName AS [Last Name],
pc_index_workparty.FirstName AS [First Name],
pc_index_workparty.pxInsName AS [pxInsName],
pc_index_workparty.pzInsKey AS [pzInsKey],
pc_index_workparty.pxpartySubscript as "Workparty"
from dbo.pc_assign_worklist
LEFT OUTER JOIN dbo.pc_index_workparty
ON pc_index_workparty.pzInsKey LIKE '%' + pc_assign_worklist.pxRefObjectInsName + '%'
where
pxAssignedOperatorID = 'dasxkx1'

i also tried left inner join but it always returns the same result seta.
I even created a view by inner join of two tables and then did left outer join on the second table . The result is same.

Can somebody tell whether this is achivable or not.

View 7 Replies View Related

Need Help: Join Tables

Sep 7, 2007

I have tbPrice:

Item, EffectiveDate, Price

and I have tbTransaction:

TransDate, Item

tbPrice created only if the price is changed, its not exist in everyday, If transdate not exist in tbPrice then find the nearest date

how to make query of this?
TransDate, Item, Price


Thank You

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved