I have two tables
tbl_1_id_pk
tbl_1_diska_fk (relationship) ---> tbl_2_id_pk
tbl_1_diskb_fk (relationship) ---> tbl_2_id_pk
and
tbl_2_id_pk
tbl_2_name
When I create views/queries for the name for each disk, it returns nothing. Why?
I have two tables
tbl_1_id_pk
tbl_1_diska_fk (relationship) ---> tbl_2_id_pk
tbl_1_diskb_fk (relationship) ---> tbl_2_id_pk
and
tbl_2_id_pk
tbl_2_name
When I create views/queries for the name for each disk, it returns nothing. Why?
What's the code to your view/query? You're probably not joining correctly to get the results you want.
Never-mind, I was using tbl_2 as a "lookup table", but determined that my views, stored_procs, and queries will just end up a mess.... Plus, using linq2sql turns my ORM into a mess as well. So I figure I will just input the name into the table. Normalization is a pain and sometimes it's not worth it or you end up with MUCK! lol
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.