Click here to Skip to main content
15,917,702 members
Home / Discussions / Database
   

Database

 
AnswerRe: i need some urgent help in this issue ! Pin
Colin Angus Mackay26-Sep-07 13:24
Colin Angus Mackay26-Sep-07 13:24 
GeneralRe: i need some help in this issue ! Pin
matched3-Oct-07 17:20
matched3-Oct-07 17:20 
GeneralRe: i need some help in this issue ! Pin
Colin Angus Mackay3-Oct-07 21:26
Colin Angus Mackay3-Oct-07 21:26 
QuestionDrag-And-Drop Binding - Simple Question Pin
ekareem26-Sep-07 7:53
ekareem26-Sep-07 7:53 
QuestionWebService Sql Notification - Advice Pin
markpirvine26-Sep-07 6:46
markpirvine26-Sep-07 6:46 
QuestionChanging Procedure from Old DB to New DB Pin
lcerni26-Sep-07 5:33
lcerni26-Sep-07 5:33 
QuestionSelect multiple rows in single row view Pin
Juan Pablo G.C.26-Sep-07 3:47
Juan Pablo G.C.26-Sep-07 3:47 
AnswerRe: Select multiple rows in single row view Pin
andyharman26-Sep-07 4:05
professionalandyharman26-Sep-07 4:05 
If you just have 2 shops then:
select i.Code, i.Name, p1.Price as PriceShop1, p2.Price as PriceShop2
from Items i
left outer join Prices as p1
  on p1.Code = i.Code
  and p1.Shop = 1
left outer join Prices as p2
  on p2.Code = i.Code
  and p2.Shop = 2
order by i.Code
This links to the Prices table twice (one for shop 1 and once for shop 2). The "p1" and "p2" bits are "alias" names for these joins.

If you have more shops then you should try searching google for "crosstab queries".

Regards
Andy
AnswerRe: Select multiple rows in single row view Pin
Paddy Boyd26-Sep-07 5:46
Paddy Boyd26-Sep-07 5:46 
GeneralRe: Select multiple rows in single row view Pin
Juan Pablo G.C.26-Sep-07 21:26
Juan Pablo G.C.26-Sep-07 21:26 
AnswerRe: Select multiple rows in single row view Pin
Venkataramuc26-Sep-07 23:28
Venkataramuc26-Sep-07 23:28 
QuestionADO.Net Pin
Kronfolitto26-Sep-07 3:22
Kronfolitto26-Sep-07 3:22 
AnswerRe: ADO.Net Pin
pmarfleet26-Sep-07 4:10
pmarfleet26-Sep-07 4:10 
Questioncommand to display total tables from database Pin
subbu.sk26-Sep-07 1:39
subbu.sk26-Sep-07 1:39 
AnswerRe: command to display total tables from database Pin
Pete O'Hanlon26-Sep-07 1:45
mvePete O'Hanlon26-Sep-07 1:45 
GeneralRe: command to display total tables from database Pin
subbu.sk26-Sep-07 1:51
subbu.sk26-Sep-07 1:51 
AnswerRe: command to display total tables from database Pin
ganeshMohan26-Sep-07 1:51
ganeshMohan26-Sep-07 1:51 
AnswerRe: command to display total tables from database Pin
Venkataramuc26-Sep-07 23:38
Venkataramuc26-Sep-07 23:38 
QuestionValiadation by Matching two tables Pin
Vimalsoft(Pty) Ltd25-Sep-07 21:49
professionalVimalsoft(Pty) Ltd25-Sep-07 21:49 
AnswerRe: Valiadation by Matching two tables Pin
pmarfleet25-Sep-07 22:01
pmarfleet25-Sep-07 22:01 
GeneralRe: Valiadation by Matching two tables Pin
Vimalsoft(Pty) Ltd25-Sep-07 22:22
professionalVimalsoft(Pty) Ltd25-Sep-07 22:22 
GeneralRe: Valiadation by Matching two tables Pin
Paddy Boyd25-Sep-07 23:02
Paddy Boyd25-Sep-07 23:02 
GeneralRe: Valiadation by Matching two tables Pin
Vimalsoft(Pty) Ltd25-Sep-07 23:13
professionalVimalsoft(Pty) Ltd25-Sep-07 23:13 
GeneralRe: Valiadation by Matching two tables Pin
andyharman25-Sep-07 23:06
professionalandyharman25-Sep-07 23:06 
GeneralRe: Valiadation by Matching two tables Pin
Vimalsoft(Pty) Ltd25-Sep-07 23:29
professionalVimalsoft(Pty) Ltd25-Sep-07 23:29 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.