my left column not display data - All SQL Server Versions - LearnSqlServer.com's SQL Server Forums

Member of the LearnItFirst.com Video Training Network	\| LearnSqlServer.com \| SQL SSIS Training \| SQL Programming Tutorials \|

Welcome Guest

Search | New Posts | Members | Log In | Register

LearnSqlServer.com's SQL Server Forums » SQL Server Scripts, Code Samples and SSMS Custom Reports » All SQL Server Versions » my left column not display data

my left column not display data

Options

Previous Topic · Next Topic

ejoeyz_85

Posted: Monday, January 14, 2008 8:50:55 AM

Rank: Newbie

Joined: 1/14/2008
Posts: 5
Points: 15
Location: Sg Buloh

this is my command

Quote:

SELECT u.SysUser_fname, pv.PV_address, p.Start_monitoring, p.Last_monitoring, p.Period_of_monitoring, m.Ongoing_maintenance,
m.Savings_for_inverter_replacement, m.Monitoring, m.Total_anual_maint_and_monitor
FROM PerformanceData AS p LEFT JOIN
MonitoringCost AS m ON p.Performance_id = m.MonitoringCost_id LEFT JOIN
Photovoltaic AS pv ON p.Performance_id = pv.PV_id AND m.MonitoringCost_id = pv.PV_id LEFT JOIN
SysUser AS u ON p.Performance_id = u.SysUser_id AND pv.PV_id = u.SysUser_id AND m.MonitoringCost_id = u.SysUser_id

below is my output

http://www.postimage.org/image.php?v=Pq4raslS

how to display data because dat column has data...

Scott Whigham

Posted: Monday, January 14, 2008 2:14:24 PM

Rank: Super Mod

Joined: 3/20/2006
Posts: 329
Points: 700
Location: Dallas, TX

One of two things: (1) your SysUser table (aliased as u and referenced as u.SysUser_fname) table does not have a matching row, or (2) there are NULLs in the SysUser table in that column. I would double check your query because this part looks wonky: ON p.Performance_id = u.SysUser_id

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.