Home Select Top 1 from one table and all linked values from another in SQL
Reply: 0

Select Top 1 from one table and all linked values from another in SQL

user452
1#
user452 Published in July 17, 2018, 7:57 am

I have two tables

Table Tbl_Headline

ID_key
News_Type

Table Tbl_Item

Item_ID
ID_key

I need to get the top 1 from Tbl_Headline but all the Item_ID's from the second table that match on that ID_key in one query

Probably code 101 but I'm having a mental block

Thanks for any help

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.369431 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO