Click here to Skip to main content
16,020,811 members
Home / Discussions / Database
   

Database

 
AnswerRe: T-SQL Developer needed for hire. Pin
Mycroft Holmes15-Apr-12 13:54
professionalMycroft Holmes15-Apr-12 13:54 
GeneralRe: T-SQL Developer needed for hire. Pin
SQL Ed16-Apr-12 0:32
SQL Ed16-Apr-12 0:32 
GeneralRe: T-SQL Developer needed for hire. Pin
SQL Ed16-Apr-12 0:32
SQL Ed16-Apr-12 0:32 
GeneralRe: T-SQL Developer needed for hire. Pin
Mycroft Holmes16-Apr-12 3:15
professionalMycroft Holmes16-Apr-12 3:15 
AnswerRe: T-SQL Developer needed for hire. Pin
PIEBALDconsult15-Apr-12 18:47
mvePIEBALDconsult15-Apr-12 18:47 
Questionselect in star schema Pin
mrx10014-Apr-12 22:34
mrx10014-Apr-12 22:34 
AnswerRe: select in star schema Pin
phil.o14-Apr-12 22:46
professionalphil.o14-Apr-12 22:46 
GeneralRe: select in star schema Pin
mrx10014-Apr-12 23:04
mrx10014-Apr-12 23:04 
i have used union

select mall.name from mall,places where mall.place_id=places.id UNION select hospital.name from hospital,places where hospital.place_id=places.id UNION select clinic.name from clinic,places where clinic.place_id=places.id UNION select shop.name from shop,places where shop.place_id=places.id

but it's very long i should select name from 25 table
can you use nested query i think it will solve the problem
QuestionRe: select in star schema Pin
Eddy Vluggen15-Apr-12 0:45
professionalEddy Vluggen15-Apr-12 0:45 
AnswerRe: select in star schema Pin
Luc Pattyn15-Apr-12 3:29
sitebuilderLuc Pattyn15-Apr-12 3:29 
AnswerRe: select in star schema Pin
Mycroft Holmes14-Apr-12 22:56
professionalMycroft Holmes14-Apr-12 22:56 
GeneralRe: select in star schema Pin
mrx10014-Apr-12 23:05
mrx10014-Apr-12 23:05 
GeneralRe: select in star schema Pin
Mycroft Holmes15-Apr-12 13:50
professionalMycroft Holmes15-Apr-12 13:50 
AnswerRe: select in star schema Pin
Bernhard Hiller15-Apr-12 22:00
Bernhard Hiller15-Apr-12 22:00 
Questionselect in star schema Pin
mrx10014-Apr-12 22:34
mrx10014-Apr-12 22:34 
QuestionCombobox in datagrid Pin
Member 828136613-Apr-12 6:19
Member 828136613-Apr-12 6:19 
AnswerRe: Combobox in datagrid Pin
Mycroft Holmes13-Apr-12 12:58
professionalMycroft Holmes13-Apr-12 12:58 
QuestionPaging in SQL Pin
Billa212-Apr-12 20:46
Billa212-Apr-12 20:46 
AnswerRe: Paging in SQL Pin
cjb11013-Apr-12 0:43
cjb11013-Apr-12 0:43 
GeneralRe: Paging in SQL Pin
Billa213-Apr-12 15:12
Billa213-Apr-12 15:12 
AnswerSQL Server script to find table dependencies Pin
jujiro12-Apr-12 8:36
jujiro12-Apr-12 8:36 
GeneralRe: SQL Server script to find table dependencies Pin
PIEBALDconsult12-Apr-12 8:57
mvePIEBALDconsult12-Apr-12 8:57 
GeneralRe: SQL Server script to find table dependencies Pin
jujiro12-Apr-12 9:06
jujiro12-Apr-12 9:06 
GeneralRe: SQL Server script to find table dependencies Pin
PIEBALDconsult12-Apr-12 9:08
mvePIEBALDconsult12-Apr-12 9:08 
GeneralRe: SQL Server script to find table dependencies Pin
Chris Meech13-Apr-12 2:46
Chris Meech13-Apr-12 2:46 

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.