Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bharatvly
Starting Member
1 Post |
 Posted - 2014-09-30 : 06:09:29
|
| Hi Team,I write very basic SQL queries and for some reason below query isn't pulling any data. It is blank. Can someone help please if anythign is wrong here?select p.provider_id, p.provider_name, cps.provider_status_name, ces.external_system_name, cpt.property_tier_namefrom provider p, c_provider_status cps, extsys_content esc, c_external_system ces, c_property_tier cpt, property_config pc, c_property_config_param cpcpwhere p.provider_status_code = cps.provider_status_codeand ces.external_system_id = esc.external_system_idand p.provider_id = esc.provider_idand ces.external_system_id in ('82')and pc.provider_id = p.provider_idand pc.config_param_value = cpt.property_tier_idand pc.property_config_param_id = cpcp.property_config_param_idand cpcp.property_config_param_id in ('5');Bharat. |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-09-30 : 10:35:38
|
| Please post some sample data as 1. CREATE TABLE commands for the tables involved2. INSERT INTO commands to populate the tables with test data3. The results you get by running your query against the tables built in steps 1 and 24. The results you want when run against the same data. |
 |
|
|
|
|
|
No results