how do i create join views in MS SQL and in mySQL. in mySQL it is almost impossible
any one with an idea

Both in mysql and ms sql joined view work.

You create them just like you would any other view, instead of your table name in the from, just use the view name

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.