Create view to know missing records between two tables

I have two tables, Tab_A is a template that generate Tab_B. Tab_A: ID, ORDER, ASSEMBLY, DESCRIPTION.

Tab_B: ID, ORDER, ASSEMBLY, DESCRIPTION.

Tab_B in same situation might have less records then his template Tab_A.

How can I create a view to know less records? Best regards

Replay

Category: sql server Time: 2016-07-28 Views: 0
Tags: sql server

Related post

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development

search

Front-end development

Database

development tools

Open Platform

Javascript development

.NET development

cloud computing

server

Copyright (C) avrocks.com, All Rights Reserved.

processed in 0.215 (s). 12 q(s)