question

vuongmaopro avatar image
vuongmaopro asked

get field x in database with sql query

i hope someone can you help me: I have 4 table as below: 1/ IMS 2/ Daily 3/ Weekly 4/ Monthly get field X with sql language. X = Weekly::K (relationship la monthly1 = weekly1) K = a1+a2+a3+a4+a5+a6 **Weekly and Daily table** a1 = Daily::b1 (relationship weekly_1 = daily_1) a2 = Daily::b2 (relationship weekly_2 = daily_1) a3 = Daily::b3 (relationship weekly_3 = daily_1) a4 = Daily::b4 (relationship weekly_4 = daily_1) a5 = Daily::b5 (relationship weekly_5 = daily_1) a6 = Daily::b6 (relationship weekly_6 = daily_1) **Daily and Ims table** b1 = sum(IMS::c) (relationship daily_1 = ims_1) b2 = sum(IMS::c) (relationship daily_2 = ims_1) b3 = sum(IMS::c) (relationship daily_3 = ims_1) b4 = sum(IMS::c) (relationship daily_4 = ims_1) b5 = sum(IMS::c) (relationship daily_5 = ims_1) b6 = sum(IMS::c) (relationship daily_6 = ims_1) Thank you very much.
sql-server-2005oracle
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
I'm sorry, I don't understand the question at all. Can you clarify further?
1 Like 1 ·
ThomasRushton avatar image ThomasRushton ♦♦ commented ·
I'm with @Grant. Oh, and can you clarify if this is a SQL Server problem or an Oracle problem? You've tagged the question as both...
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.